Overview

Dataset statistics

Number of variables12
Number of observations2969
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory301.5 KiB
Average record size in memory104.0 B

Variable types

Numeric11
Categorical1

Alerts

qtde_products has a high cardinality: 2965 distinct valuesHigh cardinality
gross_revenue is highly overall correlated with qtde_invoices and 2 other fieldsHigh correlation
recency_days is highly overall correlated with qtde_invoicesHigh correlation
qtde_invoices is highly overall correlated with gross_revenue and 2 other fieldsHigh correlation
qtde_items is highly overall correlated with gross_revenue and 2 other fieldsHigh correlation
avg_ticket is highly overall correlated with avg_unique_basket_sizeHigh correlation
avg_recency_days is highly overall correlated with frequencyHigh correlation
frequency is highly overall correlated with avg_recency_daysHigh correlation
avg_basket_size is highly overall correlated with gross_revenue and 1 other fieldsHigh correlation
avg_unique_basket_size is highly overall correlated with avg_ticketHigh correlation
qtde_items is highly skewed (γ1 = 28.51529748)Skewed
avg_ticket is highly skewed (γ1 = 53.4442279)Skewed
frequency is highly skewed (γ1 = 24.88037069)Skewed
qtde_returns is highly skewed (γ1 = 51.79774426)Skewed
avg_basket_size is highly skewed (γ1 = 44.68328098)Skewed
qtde_products is uniformly distributedUniform
customer_id has unique valuesUnique
recency_days has 34 (1.1%) zerosZeros
qtde_returns has 1481 (49.9%) zerosZeros

Reproduction

Analysis started2023-03-05 16:38:18.138416
Analysis finished2023-03-05 16:38:35.175809
Duration17.04 seconds
Software versionydata-profiling vv4.0.0
Download configurationconfig.json

Variables

customer_id
Real number (ℝ)

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15270.773
Minimum12347
Maximum18287
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:35.273524image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum12347
5-th percentile12619.4
Q113799
median15221
Q316768
95-th percentile17964.6
Maximum18287
Range5940
Interquartile range (IQR)2969

Descriptive statistics

Standard deviation1718.9903
Coefficient of variation (CV)0.11256734
Kurtosis-1.2060947
Mean15270.773
Median Absolute Deviation (MAD)1488
Skewness0.031607859
Sum45338925
Variance2954927.6
MonotonicityNot monotonic
2023-03-05T13:38:35.408116image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
17850 1
 
< 0.1%
17588 1
 
< 0.1%
14905 1
 
< 0.1%
16103 1
 
< 0.1%
14626 1
 
< 0.1%
14868 1
 
< 0.1%
18246 1
 
< 0.1%
17115 1
 
< 0.1%
16611 1
 
< 0.1%
15912 1
 
< 0.1%
Other values (2959) 2959
99.7%
ValueCountFrequency (%)
12347 1
< 0.1%
12348 1
< 0.1%
12352 1
< 0.1%
12356 1
< 0.1%
12358 1
< 0.1%
12359 1
< 0.1%
12360 1
< 0.1%
12362 1
< 0.1%
12364 1
< 0.1%
12370 1
< 0.1%
ValueCountFrequency (%)
18287 1
< 0.1%
18283 1
< 0.1%
18282 1
< 0.1%
18277 1
< 0.1%
18276 1
< 0.1%
18274 1
< 0.1%
18273 1
< 0.1%
18272 1
< 0.1%
18270 1
< 0.1%
18269 1
< 0.1%

gross_revenue
Real number (ℝ)

Distinct2954
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2749.2261
Minimum6.2
Maximum279138.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:35.537756image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum6.2
5-th percentile229.77
Q1570.96
median1086.92
Q32308.06
95-th percentile7219.68
Maximum279138.02
Range279131.82
Interquartile range (IQR)1737.1

Descriptive statistics

Standard deviation10580.491
Coefficient of variation (CV)3.8485342
Kurtosis353.95857
Mean2749.2261
Median Absolute Deviation (MAD)672.72
Skewness16.777879
Sum8162452.2
Variance1.1194678 × 108
MonotonicityNot monotonic
2023-03-05T13:38:35.661370image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178.96 2
 
0.1%
533.33 2
 
0.1%
889.93 2
 
0.1%
2053.02 2
 
0.1%
745.06 2
 
0.1%
379.65 2
 
0.1%
2092.32 2
 
0.1%
731.9 2
 
0.1%
1353.74 2
 
0.1%
331 2
 
0.1%
Other values (2944) 2949
99.3%
ValueCountFrequency (%)
6.2 1
< 0.1%
13.3 1
< 0.1%
15 1
< 0.1%
36.56 1
< 0.1%
45 1
< 0.1%
52 1
< 0.1%
52.2 1
< 0.1%
52.2 1
< 0.1%
62.43 1
< 0.1%
68.84 1
< 0.1%
ValueCountFrequency (%)
279138.02 1
< 0.1%
259657.3 1
< 0.1%
194550.79 1
< 0.1%
168472.5 1
< 0.1%
140438.72 1
< 0.1%
124564.53 1
< 0.1%
117375.63 1
< 0.1%
91062.38 1
< 0.1%
72882.09 1
< 0.1%
66653.56 1
< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct272
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.288649
Minimum0
Maximum373
Zeros34
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:35.796993image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q111
median31
Q381
95-th percentile242
Maximum373
Range373
Interquartile range (IQR)70

Descriptive statistics

Standard deviation77.756171
Coefficient of variation (CV)1.2094852
Kurtosis2.7780386
Mean64.288649
Median Absolute Deviation (MAD)26
Skewness1.7983969
Sum190873
Variance6046.0221
MonotonicityNot monotonic
2023-03-05T13:38:35.927611image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 99
 
3.3%
4 87
 
2.9%
2 85
 
2.9%
3 85
 
2.9%
8 76
 
2.6%
10 67
 
2.3%
9 66
 
2.2%
7 66
 
2.2%
17 64
 
2.2%
22 55
 
1.9%
Other values (262) 2219
74.7%
ValueCountFrequency (%)
0 34
 
1.1%
1 99
3.3%
2 85
2.9%
3 85
2.9%
4 87
2.9%
5 43
1.4%
7 66
2.2%
8 76
2.6%
9 66
2.2%
10 67
2.3%
ValueCountFrequency (%)
373 2
0.1%
372 4
0.1%
371 1
 
< 0.1%
368 1
 
< 0.1%
366 4
0.1%
365 2
0.1%
364 1
 
< 0.1%
360 1
 
< 0.1%
359 1
 
< 0.1%
358 4
0.1%

qtde_invoices
Real number (ℝ)

Distinct56
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.7228023
Minimum1
Maximum206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:36.070196image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile17
Maximum206
Range205
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.8566539
Coefficient of variation (CV)1.5476079
Kurtosis190.82536
Mean5.7228023
Median Absolute Deviation (MAD)2
Skewness10.766456
Sum16991
Variance78.440319
MonotonicityNot monotonic
2023-03-05T13:38:36.440107image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 786
26.5%
3 498
16.8%
4 393
13.2%
5 237
 
8.0%
1 190
 
6.4%
6 173
 
5.8%
7 138
 
4.6%
8 98
 
3.3%
9 69
 
2.3%
10 55
 
1.9%
Other values (46) 332
11.2%
ValueCountFrequency (%)
1 190
 
6.4%
2 786
26.5%
3 498
16.8%
4 393
13.2%
5 237
 
8.0%
6 173
 
5.8%
7 138
 
4.6%
8 98
 
3.3%
9 69
 
2.3%
10 55
 
1.9%
ValueCountFrequency (%)
206 1
< 0.1%
199 1
< 0.1%
124 1
< 0.1%
97 1
< 0.1%
91 2
0.1%
86 1
< 0.1%
72 1
< 0.1%
62 2
0.1%
60 1
< 0.1%
57 1
< 0.1%

qtde_items
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct741
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean383.05423
Minimum1
Maximum80996
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:36.568730image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile35
Q184
median153
Q3290
95-th percentile930.6
Maximum80996
Range80995
Interquartile range (IQR)206

Descriptive statistics

Standard deviation1940.6515
Coefficient of variation (CV)5.0662579
Kurtosis1067.0901
Mean383.05423
Median Absolute Deviation (MAD)85
Skewness28.515297
Sum1137288
Variance3766128.2
MonotonicityNot monotonic
2023-03-05T13:38:36.705951image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
60 28
 
0.9%
70 26
 
0.9%
67 24
 
0.8%
66 23
 
0.8%
120 22
 
0.7%
90 22
 
0.7%
52 21
 
0.7%
84 20
 
0.7%
69 19
 
0.6%
75 19
 
0.6%
Other values (731) 2745
92.5%
ValueCountFrequency (%)
1 3
0.1%
3 2
 
0.1%
6 2
 
0.1%
8 1
 
< 0.1%
9 1
 
< 0.1%
10 4
0.1%
11 1
 
< 0.1%
12 6
0.2%
13 1
 
< 0.1%
15 2
 
0.1%
ValueCountFrequency (%)
80996 1
< 0.1%
38639 1
< 0.1%
21352 1
< 0.1%
17376 1
< 0.1%
17150 1
< 0.1%
16288 1
< 0.1%
15837 1
< 0.1%
12872 1
< 0.1%
12869 1
< 0.1%
10827 1
< 0.1%

qtde_products
Categorical

HIGH CARDINALITY  UNIFORM 

Distinct2965
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
2123221231
 
2
85099B
 
2
79321
 
2
85123A21733
 
2
47504K2171422487213408476322926218962189422605224432244217129F2248884796B84279B229252260784078A84795B2330123300849782260622687
 
1
Other values (2960)
2960 

Length

Max length9158
Median length1061
Mean length403.21489
Min length5

Characters and Unicode

Total characters1197145
Distinct characters33
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2961 ?
Unique (%)99.7%

Sample

1st row85123A7105384406B84029G84029E22752217302263322632206793737021871210712106882483824868248282494L15056BL2280322411
2nd row848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P2276622708232318501585016228292272222961229692272022549209722274321658481842269222274224992260747566219022190121899219002207785123A23152231822316123160231632316223164231772317623006229962307023126232992242321621230922311223110231112311823093230892316823236232402317523173232452303223031230292302885053220902208922088235462354522986227392343522621481882289922367235142351323511231982329423295230252347023397230962348723109234342208685049E
3rd row227282272722726217242188310002217912103522326226292265922631226612173122900219132254022544224922108621080227292112120750225512255622555223902233322331207192104222367210942253922554219812261522616226141621823007230102155921240221972209022991230092328023281224342123820724210392121221154209832098121245843802310021244212422329821210223562246622610226092256123124229552263635970219882198921987220812208222080211562344523169233282338823389233902337323374227782336823367235062350922352234802357022951224172197622083223282120722730216802233223598230842356222909226132261723515
4th row220862284322841228392242322907229612258522084212322245723378231292207722950233512335023319233548494622734229522301323012
5th row21258

Common Values

ValueCountFrequency (%)
2123221231 2
 
0.1%
85099B 2
 
0.1%
79321 2
 
0.1%
85123A21733 2
 
0.1%
47504K2171422487213408476322926218962189422605224432244217129F2248884796B84279B229252260784078A84795B2330123300849782260622687 1
 
< 0.1%
22992232532219747590B47590A849872167321670216692167121668216722266847566207502269922698226972246722487213402074947591D374493744647566B48185224234819422499224982266921352220842208322781221912219322192215247145922719231522317223171231702334223341233132174522734220862291023091233282313623414 1
 
< 0.1%
230522305022766230532305121654220872267779030G230542304922680226822268322170230922276785123A2218972812226762267985032D84806B90030A90030C22678233232332720956 1
 
< 0.1%
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A224232277621974216712167221670216692166822089222952322720829848792247022670231472222485099F22386232002192821929481942246947566207232320422356223147000622409234722353123484235438499285099B223762157720713233432335684078A2244122169227682198321984233782308484978231732269822697231752269923382234802348923528235292352323527235422238522663233442280922810229422294185048849457147723313 1
 
< 0.1%
223492230122300227492260622620226072260522998228992290422741227522097722821223842072822728227302296922993229072290522665232092227320969209702215022147714772191223229225702256823119224932097220971227582275421935219342238223206207272238322961217912256922564225632072522667232752214921914219152269322759225622263222633234392286622865228672349323504235032294022142221412214421731230842255422555225572211222835231982266623158230822308323100232672338923480226212349423355221143597022556 1
 
< 0.1%
710532208721340 1
 
< 0.1%
Other values (2955) 2955
99.5%

Length

2023-03-05T13:38:36.863494image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
charges 5
 
0.2%
2123221231 2
 
0.1%
79321 2
 
0.1%
85123a21733 2
 
0.1%
85099b 2
 
0.1%
2278322961229602266385049a2216822662224872320222385232002320122382232072320623199230652324223241232032325321929219283597023100231032348923344 1
 
< 0.1%
2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a2243722436852272298322030211992182921294223322218122271222742198923053230521625947566232982103422354213264000185107233222332123333233342333222460231092308223177851771623621703210982299723501235042350222621227552183223188230842207485049c1622522144229102075823434234352331123406227282335282616c23044224912339523393233942278523569235702357184029g21479233192331884012235312278123486 1
 
< 0.1%
227282272722726217242188310002217912103522326226292265922631226612173122900219132254022544224922108621080227292112120750225512255622555223902233322331207192104222367210942253922554219812261522616226141621823007230102155921240221972209022991230092328023281224342123820724210392121221154209832098121245843802310021244212422329821210223562246622610226092256123124229552263635970219882198921987220812208222080211562344523169233282338823389233902337323374227782336823367235062350922352234802357022951224172197622083223282120722730216802233223598230842356222909226132261723515 1
 
< 0.1%
220862284322841228392242322907229612258522084212322245723378231292207722950233512335023319233548494622734229522301323012 1
 
< 0.1%
21258 1
 
< 0.1%
Other values (2961) 2961
99.4%

Most occurring characters

ValueCountFrequency (%)
2 364877
30.5%
1 125815
 
10.5%
3 122243
 
10.2%
8 89844
 
7.5%
9 85137
 
7.1%
0 84119
 
7.0%
4 82338
 
6.9%
5 79637
 
6.7%
7 76677
 
6.4%
6 66494
 
5.6%
Other values (23) 19964
 
1.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1177181
98.3%
Uppercase Letter 19954
 
1.7%
Space Separator 10
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
B 5353
26.8%
A 4882
24.5%
C 2574
12.9%
D 1472
 
7.4%
E 1036
 
5.2%
L 1014
 
5.1%
S 748
 
3.7%
F 697
 
3.5%
G 660
 
3.3%
P 413
 
2.1%
Other values (12) 1105
 
5.5%
Decimal Number
ValueCountFrequency (%)
2 364877
31.0%
1 125815
 
10.7%
3 122243
 
10.4%
8 89844
 
7.6%
9 85137
 
7.2%
0 84119
 
7.1%
4 82338
 
7.0%
5 79637
 
6.8%
7 76677
 
6.5%
6 66494
 
5.6%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1177191
98.3%
Latin 19954
 
1.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
B 5353
26.8%
A 4882
24.5%
C 2574
12.9%
D 1472
 
7.4%
E 1036
 
5.2%
L 1014
 
5.1%
S 748
 
3.7%
F 697
 
3.5%
G 660
 
3.3%
P 413
 
2.1%
Other values (12) 1105
 
5.5%
Common
ValueCountFrequency (%)
2 364877
31.0%
1 125815
 
10.7%
3 122243
 
10.4%
8 89844
 
7.6%
9 85137
 
7.2%
0 84119
 
7.1%
4 82338
 
7.0%
5 79637
 
6.8%
7 76677
 
6.5%
6 66494
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1197145
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 364877
30.5%
1 125815
 
10.5%
3 122243
 
10.2%
8 89844
 
7.5%
9 85137
 
7.1%
0 84119
 
7.0%
4 82338
 
6.9%
5 79637
 
6.7%
7 76677
 
6.4%
6 66494
 
5.6%
Other values (23) 19964
 
1.7%

avg_ticket
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct2966
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.900057
Minimum2.1505882
Maximum56157.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:36.994112image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum2.1505882
5-th percentile4.9166611
Q113.119333
median17.974384
Q324.988286
95-th percentile90.497
Maximum56157.5
Range56155.349
Interquartile range (IQR)11.868952

Descriptive statistics

Standard deviation1036.9343
Coefficient of variation (CV)19.979445
Kurtosis2890.7074
Mean51.900057
Median Absolute Deviation (MAD)5.9942223
Skewness53.444228
Sum154091.27
Variance1075232.8
MonotonicityNot monotonic
2023-03-05T13:38:37.118752image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15 2
 
0.1%
4.162 2
 
0.1%
14.47833333 2
 
0.1%
18.15222222 1
 
< 0.1%
13.92736842 1
 
< 0.1%
36.24411765 1
 
< 0.1%
29.78416667 1
 
< 0.1%
22.8792623 1
 
< 0.1%
20.51104167 1
 
< 0.1%
149.025 1
 
< 0.1%
Other values (2956) 2956
99.6%
ValueCountFrequency (%)
2.150588235 1
< 0.1%
2.4325 1
< 0.1%
2.462371134 1
< 0.1%
2.511241379 1
< 0.1%
2.515333333 1
< 0.1%
2.65 1
< 0.1%
2.656931818 1
< 0.1%
2.707598253 1
< 0.1%
2.760621572 1
< 0.1%
2.770464191 1
< 0.1%
ValueCountFrequency (%)
56157.5 1
< 0.1%
4453.43 1
< 0.1%
3202.92 1
< 0.1%
1687.2 1
< 0.1%
952.9875 1
< 0.1%
872.13 1
< 0.1%
841.0214493 1
< 0.1%
651.1683333 1
< 0.1%
640 1
< 0.1%
624.4 1
< 0.1%

avg_recency_days
Real number (ℝ)

Distinct1258
Distinct (%)42.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.35143
Minimum1
Maximum366
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:37.255342image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8
Q125.928571
median48.285714
Q385.333333
95-th percentile201
Maximum366
Range365
Interquartile range (IQR)59.404762

Descriptive statistics

Standard deviation63.542829
Coefficient of variation (CV)0.94345182
Kurtosis4.8877032
Mean67.35143
Median Absolute Deviation (MAD)26.285714
Skewness2.062909
Sum199966.4
Variance4037.6912
MonotonicityNot monotonic
2023-03-05T13:38:37.386944image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
14 25
 
0.8%
4 22
 
0.7%
70 21
 
0.7%
7 20
 
0.7%
35 19
 
0.6%
49 18
 
0.6%
21 17
 
0.6%
46 17
 
0.6%
11 17
 
0.6%
1 16
 
0.5%
Other values (1248) 2777
93.5%
ValueCountFrequency (%)
1 16
0.5%
1.5 1
 
< 0.1%
2 13
0.4%
2.5 1
 
< 0.1%
2.601398601 1
 
< 0.1%
3 15
0.5%
3.321428571 1
 
< 0.1%
3.330357143 1
 
< 0.1%
3.5 2
 
0.1%
4 22
0.7%
ValueCountFrequency (%)
366 1
 
< 0.1%
365 1
 
< 0.1%
363 1
 
< 0.1%
362 1
 
< 0.1%
357 2
0.1%
356 1
 
< 0.1%
355 2
0.1%
352 1
 
< 0.1%
351 2
0.1%
350 3
0.1%

frequency
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct1225
Distinct (%)41.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.11379122
Minimum0.0054495913
Maximum17
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:37.527545image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.0054495913
5-th percentile0.0088941642
Q10.016339869
median0.025889968
Q30.049418605
95-th percentile1
Maximum17
Range16.99455
Interquartile range (IQR)0.033078735

Descriptive statistics

Standard deviation0.40815715
Coefficient of variation (CV)3.5868949
Kurtosis989.35782
Mean0.11379122
Median Absolute Deviation (MAD)0.012191338
Skewness24.880371
Sum337.84614
Variance0.16659226
MonotonicityNot monotonic
2023-03-05T13:38:37.657169image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 198
 
6.7%
0.02777777778 17
 
0.6%
0.0625 17
 
0.6%
0.02380952381 16
 
0.5%
0.09090909091 15
 
0.5%
0.08333333333 15
 
0.5%
0.03448275862 14
 
0.5%
0.02941176471 14
 
0.5%
0.03571428571 13
 
0.4%
0.07692307692 13
 
0.4%
Other values (1215) 2637
88.8%
ValueCountFrequency (%)
0.005449591281 1
 
< 0.1%
0.005464480874 1
 
< 0.1%
0.005479452055 1
 
< 0.1%
0.005494505495 1
 
< 0.1%
0.005586592179 2
0.1%
0.005602240896 1
 
< 0.1%
0.005617977528 2
0.1%
0.00566572238 1
 
< 0.1%
0.005681818182 2
0.1%
0.005698005698 3
0.1%
ValueCountFrequency (%)
17 1
 
< 0.1%
3 1
 
< 0.1%
2 6
 
0.2%
1.142857143 1
 
< 0.1%
1 198
6.7%
0.75 1
 
< 0.1%
0.6666666667 3
 
0.1%
0.550802139 1
 
< 0.1%
0.5335120643 1
 
< 0.1%
0.5 3
 
0.1%

qtde_returns
Real number (ℝ)

SKEWED  ZEROS 

Distinct214
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.156955
Minimum0
Maximum80995
Zeros1481
Zeros (%)49.9%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:37.800703image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile100.6
Maximum80995
Range80995
Interquartile range (IQR)9

Descriptive statistics

Standard deviation1512.4961
Coefficient of variation (CV)24.333498
Kurtosis2765.5286
Mean62.156955
Median Absolute Deviation (MAD)1
Skewness51.797744
Sum184544
Variance2287644.6
MonotonicityNot monotonic
2023-03-05T13:38:37.939342image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1481
49.9%
1 164
 
5.5%
2 148
 
5.0%
3 105
 
3.5%
4 89
 
3.0%
6 78
 
2.6%
5 61
 
2.1%
12 51
 
1.7%
8 43
 
1.4%
7 43
 
1.4%
Other values (204) 706
23.8%
ValueCountFrequency (%)
0 1481
49.9%
1 164
 
5.5%
2 148
 
5.0%
3 105
 
3.5%
4 89
 
3.0%
5 61
 
2.1%
6 78
 
2.6%
7 43
 
1.4%
8 43
 
1.4%
9 41
 
1.4%
ValueCountFrequency (%)
80995 1
< 0.1%
9014 1
< 0.1%
8004 1
< 0.1%
4427 1
< 0.1%
3768 1
< 0.1%
3332 1
< 0.1%
2878 1
< 0.1%
2022 1
< 0.1%
2012 1
< 0.1%
1776 1
< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct1973
Distinct (%)66.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean249.34954
Minimum1
Maximum40498.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:38.087913image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44
Q1103.25
median172
Q3281.5
95-th percentile599.52
Maximum40498.5
Range40497.5
Interquartile range (IQR)178.25

Descriptive statistics

Standard deviation791.50241
Coefficient of variation (CV)3.1742686
Kurtosis2256.2455
Mean249.34954
Median Absolute Deviation (MAD)82.75
Skewness44.683281
Sum740318.79
Variance626476.07
MonotonicityNot monotonic
2023-03-05T13:38:38.225971image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 11
 
0.4%
114 10
 
0.3%
73 9
 
0.3%
86 9
 
0.3%
82 9
 
0.3%
136 8
 
0.3%
60 8
 
0.3%
75 8
 
0.3%
88 8
 
0.3%
71 7
 
0.2%
Other values (1963) 2882
97.1%
ValueCountFrequency (%)
1 2
0.1%
2 1
< 0.1%
3.333333333 1
< 0.1%
5.333333333 1
< 0.1%
5.666666667 1
< 0.1%
6.142857143 1
< 0.1%
7.5 1
< 0.1%
9 1
< 0.1%
9.5 1
< 0.1%
11 1
< 0.1%
ValueCountFrequency (%)
40498.5 1
< 0.1%
6009.333333 1
< 0.1%
4282 1
< 0.1%
3906 1
< 0.1%
3868.65 1
< 0.1%
2880 1
< 0.1%
2801 1
< 0.1%
2733.944444 1
< 0.1%
2518.769231 1
< 0.1%
2160.333333 1
< 0.1%

avg_unique_basket_size
Real number (ℝ)

Distinct1010
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.155074
Minimum1
Maximum299.70588
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size46.4 KiB
2023-03-05T13:38:38.371554image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.3454545
Q110
median17.2
Q327.75
95-th percentile56.94
Maximum299.70588
Range298.70588
Interquartile range (IQR)17.75

Descriptive statistics

Standard deviation19.513033
Coefficient of variation (CV)0.88074783
Kurtosis27.694698
Mean22.155074
Median Absolute Deviation (MAD)8.2
Skewness3.4982521
Sum65778.414
Variance380.75846
MonotonicityNot monotonic
2023-03-05T13:38:38.506134image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
13 53
 
1.8%
14 40
 
1.3%
11 38
 
1.3%
20 33
 
1.1%
9 33
 
1.1%
1 32
 
1.1%
18 31
 
1.0%
10 30
 
1.0%
16 29
 
1.0%
17 28
 
0.9%
Other values (1000) 2622
88.3%
ValueCountFrequency (%)
1 32
1.1%
1.2 1
 
< 0.1%
1.25 1
 
< 0.1%
1.333333333 2
 
0.1%
1.5 8
 
0.3%
1.568181818 1
 
< 0.1%
1.571428571 1
 
< 0.1%
1.666666667 4
 
0.1%
1.833333333 1
 
< 0.1%
2 24
0.8%
ValueCountFrequency (%)
299.7058824 1
< 0.1%
259 1
< 0.1%
203.5 1
< 0.1%
148 1
< 0.1%
145 1
< 0.1%
136.125 1
< 0.1%
135.5 1
< 0.1%
127 1
< 0.1%
122 1
< 0.1%
118 1
< 0.1%

Interactions

2023-03-05T13:38:33.441765image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:18.696652image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.092515image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.502536image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.364759image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.673972image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.245324image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.566457image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.969348image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.559691image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.023404image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.563408image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:18.844682image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.207179image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.630162image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.475435image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.911237image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.362979image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.686105image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.089994image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.694296image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.149548image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.676589image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:18.972309image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.317855image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.754797image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.587108image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.050823image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.473705image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.815773image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.422022image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.825912image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.271194image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.797236image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.092956image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.444595image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.893391image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.707756image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.189416image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.593305image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.946345image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.549649image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.955532image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.404801image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.902927image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.204630image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.548782image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:22.010050image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.810453image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.307071image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.701989image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.062048image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.664313image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.081164image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.523453image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.036536image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.330261image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.675834image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:22.141741image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.938081image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.443671image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.827619image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.192675image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.799916image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.226738image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.654071image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.157182image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.447940image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.802154image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:22.276422image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.046762image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.571347image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.947270image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.302300image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:29.917572image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.347384image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.771726image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.276831image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.578535image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:20.931783image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:22.413068image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.181368image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.713880image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.072902image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.429927image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.045197image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.481992image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:32.901347image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.406452image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.706160image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.074280image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:22.553079image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.303011image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.853471image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.194546image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.559547image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.165844image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.613605image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.033961image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.543051image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.839096image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.222356image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.115489image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.429641image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:25.990072image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.324165image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.694153image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.302444image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.741231image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.185561image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:34.672672image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:19.969121image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:21.369924image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:23.244112image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:24.556270image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:26.121687image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:27.451791image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:28.833745image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:30.435113image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:31.890793image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-03-05T13:38:33.317129image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Correlations

2023-03-05T13:38:38.627746image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
customer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
customer_id1.000-0.0760.0010.025-0.041-0.1310.019-0.002-0.063-0.123-0.007
gross_revenue-0.0761.000-0.4150.7700.7110.246-0.2480.0900.3720.5760.291
recency_days0.001-0.4151.000-0.502-0.2900.0480.1080.018-0.119-0.098-0.106
qtde_invoices0.0250.770-0.5021.0000.5310.059-0.2580.0780.2930.1010.025
qtde_items-0.0410.711-0.2900.5311.0000.348-0.1650.0570.2580.6690.061
avg_ticket-0.1310.2460.0480.0590.3481.000-0.1220.0910.1900.189-0.611
avg_recency_days0.019-0.2480.108-0.258-0.165-0.1221.000-0.881-0.396-0.0770.048
frequency-0.0020.0900.0180.0780.0570.091-0.8811.0000.2340.027-0.072
qtde_returns-0.0630.372-0.1190.2930.2580.190-0.3960.2341.0000.2110.019
avg_basket_size-0.1230.576-0.0980.1010.6690.189-0.0770.0270.2111.0000.448
avg_unique_basket_size-0.0070.291-0.1060.0250.061-0.6110.048-0.0720.0190.4481.000

Missing values

2023-03-05T13:38:34.846164image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-03-05T13:38:35.072551image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

customer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
0178505391.2100372.000034.000035.000085123A7105384406B84029G84029E22752217302263322632206793737021871210712106882483824868248282494L15056BL228032241118.152235.500017.000040.000050.97068.7353
1130473232.590056.00009.0000131.0000848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P2276622708232318501585016228292272222961229692272022549209722274321658481842269222274224992260747566219022190121899219002207785123A23152231822316123160231632316223164231772317623006229962307023126232992242321621230922311223110231112311823093230892316823236232402317523173232452303223031230292302885053220902208922088235462354522986227392343522621481882289922367235142351323511231982329423295230252347023397230962348723109234342208685049E18.904027.25000.028335.0000154.444419.0000
2125836705.38002.000015.00001568.000022728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022729211212075022551225562255522390223332233120719210422236721094225392255421981226152261622614162182300723010215592124022197220902299123009232802328122434212382072421039212122115420983209812124584380231002124421242232982121022356224662261022609225612312422955226363597021988219892198722081220822208021156234452316923328233882338923390233732337422778233682336723506235092235223480235702295122417219762208322328212072273021680223322359823084235622290922613226172351528.902523.18750.040350.0000335.200015.4667
313748948.250095.00005.0000169.000022086228432284122839224232290722961225852208421232224572337823129220772295023351233502331923354849462273422952230132301233.866192.66670.01790.000087.80005.6000
415100876.0000333.00003.000048.000021258292.00008.60000.073222.000026.66671.0000
5152914623.300025.000014.0000508.0000221142173382484824862175422424225052276821755217562217084406B848792113685066227962229422487481884819420685847552162121623229682275922762222412228848185215242221922173221894813848111212322125984970L228552221246000S2282221523714772278421673216722166921668228442285222845228534818421670225782257922577221122335545.326523.20000.040129.0000150.14297.2857
6146885630.87007.000021.0000579.00002238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234448188223792238185099B21080210868499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M2186422090793214811148173C223802235621902221972072420719223552299622995229982299779302M461182193221937206752067621925216212205377101A2143046126A212392124021238212422198922179229532193621172231822103479026B21899217702067779051A84828232982320421165232058255182552226742319923201207272193022384207282116221163233212308085099F2155820711224672334822138214272261723485233282174223301231692358316258A21949231942324123471235011623621832162372355220986235712249123126231272227422475221912098285135C85136A2319221754217562358117.219818.30000.0572399.0000172.428615.5714
7178095411.910016.000012.0000961.0000229612294322617225692256884032B84032A22749229402290922652229102258521523226244813823284232982298822366214632146422334210342233310120162352243921914212202132920974218292338222950221412214223312225612318822991229922319284692233008434788.719835.70000.033541.0000171.41675.0833
81531160767.90000.000091.00002167.0000221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S47580222618483222644215332155715056BL15056N2264622176224382173122778227192152322620849462103384865211722150484563A84563B2250221867216732277585035B84378228912189982613B825992115885014A374462235521258793213744935004C84559B84997D84415B2065522170206772123922088220902090622175212432109837444B3733321212218722125984978840502290984997C2124420675212402155921470227882276621563725988248682494L20829228442284585184C22910400012283420750217742123120719207262080248173C848362167084849D2274622563225622275621949212452067484997B826002272321832223132244585136A481112224285099B21668220872219822171824832156121558223522165884509A22384217732252385036A21988219892089782613C2138021669216712144521447214392232521564211212224122378212382106884970L84970S84989A211552073375049L8475582484849478515284997A228052193185099F207252072720728207182072420676212422210384993A22773227722257182001S2188182482217542116421080218442264521035210412075422356212102112320713219302192884510A72799F85099C37448221972206185232A84520B2249472760B21122224702132921328213272290884509C21313206794742147422217332252185032B85019A85163B160162175585167B2211247559B2194717136A2066582581825832227822276211632115984912B214672208984596B84596F2198720685206188494985014B85150215562275222151221522231822247851872236122363223642216285200207122145647590A85205B359202138922284221213592484912A2229185185B35637A3592185188A22281227702111085071D21883219292131422663223852261385071A22418224202116584750B2153782613A17129F481872138622525219362210121218481854811671459221042232121884224672255822755227582275322754227572224321171231992320123205232042266123208232068519715056P2145971279219552072322383223822071122386226702318222671226722267522674226738505322457223322233122333223348478921012218644000321792212112279621408231402314121115232562316822427230842319223191231902316523167231662237946138B2217847590B228968469282613D4819423034230352303371477843472308916008211372178722041211792119421208223162112423196231972319822426223152328523286232872328818097C2235417091J2257223163220452254821790224092240722406224082217921980219832198522615224682198221984219672261647310M85159A85159B20898212322290522904229031622547351B223602171621715217182142884569A84569D2310422219214242142621986217912247672802A22135214272143022410474804747122665221742142522549225602229722939229902070479302M22134231542232622328223272232923031230292303223028231844611822721223622340322173226822268322680226812268422685226792268622677226782267684406B231472314623148221322213379066K47563A2242923016215312098622500216842153023142228982289922216230362269122692224142236522366231692278144089C44089A2208522628233152331623317230262189222310232752125722227218822188021207481842181221086211742181121866846002109484375221612255621879229622296322065849458479223271233972207872800E35001G481888520285204852032226522794442354423421524233262311025.54354.14440.2433474.0000419.714326.1429
9160982005.630087.00007.0000240.0000100022191221832224112237922381227982272622926228392283822783227822091420681226902273022728227272309484673B84673A21888230802299222725150398407722729233152331684754232152321429.934847.66670.02440.000087.57149.5714
customer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
5627177271060.250015.00001.0000111.00008505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D2296522989224252242922426850592324323337233352319821977233072329522624226272272023245229792298022978229812298222993234952272222723229072310422557225552255622551225542337023366214302323623240217902262216.06446.00001.00006.0000645.000066.0000
563717232421.52002.00002.000066.000084347214842335622816228182369522030207772343922866207662076422867228652349423493233442214222966220812299120761215842357622144233192324022428227262272711.708912.00000.15380.0000101.500018.0000
563817468137.000010.00002.000044.0000232042246021231225962107027.40004.00000.40000.000058.00002.5000
564913596697.04005.00002.000081.00002262523345233462297823580231162285121136848422296184997A22367228992327522949210802325421715224508499223256224292236023293218772197584991231732209123289232902197223313233382296621592229552295122326849882103448187233722241723296235752324123177235602263023508229482262923084233062320323390234942349323343232992275422909229102290323371225512248921878226232254921889225302254323320232852328823286232872253422544225562351023389235982256322562220932273023401221112161523307234092319323194219132308022423218882162122554226622238222499225162251722514225152171884978231302244522446231972352923198233772248522956232712246022178232452323922813231902274622748232422179023367233684.19907.00000.25000.0000203.000083.0000
5655148931237.85009.00002.0000226.000085183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B16.95682.00000.66670.0000399.500036.5000
565912479473.200011.00001.000087.000021212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C2097820979209732337015.77334.00001.000034.0000382.000030.0000
568014126706.13007.00003.0000361.000022274221502227322779226212245785123A2096122605224332147923444209632256047.07533.00000.750050.0000169.33335.0000
5686135211092.39001.00003.000046.00002353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D23327233262113523074849782336721684221442215021889217902318922659224948434721616216202161585059221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C23293228312219621066232942329521314224282218222961233682336523366235522349722195233402338222592228422284022429222082220922211215342152821537359673596423163231622236747591D215922235222945232492325022977210122348922071220702250922365227702260522607219122254923526216192171384031B2067915056N229522335622111226952242484032B233942339623395233932171423536230892140121400233388498822190234942254623182226732267121787210642255785231B23241850532211822119230192308084832217188401222642843752191622123229422127922811224572240922406223982240021716224412296085061W234252241984707A220762207522476231692247484947229642310123100234183597023168229562263922638226432321423495232962126315056P2068622170209922198423504233762350623510222802227985176223892255190214E2253022544225332253422744227432349390214P90214I21739207332170522500229402097285015150392111521891218902209622754209962189423144212602138384993A84879211362252285169A85169C85026B22495233092213222099233982098622097219768499122139214392318821993235512110922473224222339947469221102221079063C2312221638216402097522074225632256222564222762207222109221082212484596B2325222475223142293870006225612295522472848192159184692223432156321530219772312320868217152321221162232152180821803220942.51124.50000.30000.0000244.3333145.0000
569615060301.84008.00004.000057.000022485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369422028222092226635810B2161621619216158511185183A2250023395233942265423198223582250722278210348517723378233762357117012D17012B22585851762257822577233592220822697223782335421080233522335123570221151625485032B22349223482198085032C2275422755207552077721428206682203022402232912329223499219162.51531.00002.00000.000065.500030.0000
571512558269.96007.00001.0000102.0000227122334485099B2320979191C23392848282315821507215082202724.54186.00001.0000196.0000196.000011.0000